<?php session_start();
if (!isset($_SESSION["username"])) {
    header("Location:userlogin.php");
} else {
    $username = $_SESSION['username'];
    $a = mysqli_connect("localhost", "root", "deng123", "housekeeping", "3306") or die("unable to connect");
    @$query = "SELECT * FROM user_details where username='$username'";
    @$result = mysqli_query($a, $query);
    if ($result) {
        while ($row = mysqli_fetch_array($result)) {
            $dbname = $row['name'];
            $dbemail = $row['email'];
            $dbphone = $row['phone'];
            $dbgender = $row['gender'];
            $dbcity = $row['city'];
            $dbarea = $row['area'];
            $dbaddress = $row['address'];
            $dbpin = $row['pin'];
?>
            <!DOCTYPE html>
            <html lang="en">

            <head>
                <!-- Required meta tags-->
                <meta charset="utf-8">
                <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
                <meta name="description" content="">
                <meta name="author" content="">
                <meta name="viewport" content="width=device-width, initial-scale=1">
                <title>好先生 | 家政服务</title>
                <link rel="shortcut icon" href="img/favicon.ico" />
                <!-- Icons font CSS-->
                <link href="vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">
                <link href="vendor/fontawesome-free/css/all.min.css" rel="stylesheet">
                <link rel="stylesheet" href="vendor/simple-line-icons/css/simple-line-icons.css">
                <link href="https://fonts.googleapis.com/css?family=Lato" rel="stylesheet">
                <link href="https://fonts.googleapis.com/css?family=Catamaran:100,200,300,400,500,600,700,800,900" rel="stylesheet">
                <link href="https://fonts.googleapis.com/css?family=Muli" rel="stylesheet">
                <link href="vendor/mdi-font/css/material-design-iconic-font.min.css" rel="stylesheet" media="all">
                <link href="vendor/font-awesome-4.7/css/font-awesome.min.css" rel="stylesheet" media="all">
                <!-- Font special for pages-->
                <link href="https://fonts.googleapis.com/css?family=Poppins:100,100i,200,200i,300,300i,400,400i,500,500i,600,600i,700,700i,800,800i,900,900i" rel="stylesheet">

                <!-- Vendor CSS-->
                <link href="vendor/select2/select2.min.css" rel="stylesheet" media="all">
                <link href="css/hover-min.css" rel="stylesheet">


                <!-- Main CSS-->
                <link href="css/main.css" rel="stylesheet" media="all">
                <link href="css/style.css" rel="stylesheet" media="all">
            </head>

            <body>
                <nav class="navbar navbar-expand-lg navbar-light fixed-top" style="background:-webkit-gradient(linear, right top, left top, from(#1da1f2), to(#005f7f));" id="mainNav">
                    <div class="container">
                        <div class="navbar-header">
                            <a class=" nav-link js-scroll-trigger" href="#top">
                                <img class="img-rounded" src="img/logo.png" />
                            </a>
                        </div>
                        &nbsp;<?php $_SESSION['name'] = $dbname; ?>
                        <a class="navbar-brand " href="#page-top">
                            <h2><small style="font-family: Arial;border-bottom: 2px solid gainsboro"><?php echo $_SESSION['name']; ?></small></h2>
                        </a>
                        <button class="navbar-toggler navbar-toggler-right ml-auto" type="button" data-toggle="collapse" data-target="#navbarResponsive" aria-controls="navbarResponsive" aria-expanded="false" aria-label="Toggle navigation">
                            菜单
                            <i class="fas fa-bars"></i>
                        </button>
                        <div class="collapse navbar-collapse" id="navbarResponsive">
                            <ul class="navbar-nav ml-auto">
                                <li class="nav-item">
                                    <a class="nav-link js-scroll-trigger hvr-glow" href="user_profile.php">用户资料</a>
                                </li>
                                <li class="nav-item">
                                    <a class="nav-link js-scroll-trigger hvr-glow " href="find_service.php">查找服务</a>
                                </li>
                                <li class="nav-item">
                                    <a class="nav-link js-scroll-trigger hvr-glow " href="user_service.php">记录</a>
                                </li>
                                <li class="nav-item">
                                    <a class="nav-link js-scroll-trigger hvr-glow " href="user_help.php">帮助</a>
                                </li>
                                <li class="nav-item">
                                    <a class="nav-link js-scroll-trigger hvr-glow " href="u_logout.php">退出</a>
                                </li>
                            </ul>
                        </div>
                    </div>
                </nav>
                <section class="features tb bb" id="features">
                    <form action="user_profile.php" method="post">
                        <input type="submit" class="cont_button2 btn-dark" value="<< 返回">
                    </form>

                    <h1 class="mb-4 text-light">我的个人资料</h1>


                    <table class="container1">
                        <tbody>
                            <tr>
                                <td>名字</td>
                                <td><?php echo $dbname; ?></td>
                            </tr>
                            <tr>
                                <td>邮箱</td>
                                <td><?php echo $dbemail; ?></td>
                            </tr>
                            <tr>
                                <td>手机号</td>
                                <td><?php echo $dbphone; ?></td>
                            </tr>
                            <tr>
                                <td>用户名</td>
                                <td><?php echo $username; ?></td>
                            </tr>
                            <tr>
                                <td>性别</td>
                                <td><?php echo $dbgender; ?></td>
                            </tr>
                            <tr>
                                <td>城市</td>
                                <td><?php echo $dbcity; ?></td>
                            </tr>
                            <tr>
                                <td>区域</td>
                                <td><?php echo $dbarea; ?></td>
                            </tr>
                            <tr>
                                <td>地址</td>
                                <td><?php echo $dbaddress; ?></td>
                            </tr>
                            <tr>
                                <td>邮政编码</td>
                                <td><?php echo $dbpin; ?></td>
                            </tr>
                        </tbody>
                    </table>
                    <div class="container1">
                        <form action="user_edit.php" method="post">
                            <input type="hidden" name="username" value="<?php echo $username; ?>">
                            <button id="contact_btn" type="submit" class="contact_button trans_100" style="float: right;" value="编辑">编辑</button>
                        </form>
                    </div>

                </section>

                <!-- Jquery JS-->
                <script src="vendor/jquery1/jquery.min.js"></script>
                <!-- Vendor JS-->
                <script src="vendor/select2/select2.min.js"></script>
                <script src="vendor/jquery-validate/jquery.validate.min.js"></script>
                <script src="vendor/bootstrap-wizard/bootstrap.min.js"></script>
                <script src="vendor/bootstrap-wizard/jquery.bootstrap.wizard.min.js"></script>
                <script src="vendor/datepicker/moment.min.js"></script>
                <script src="vendor/datepicker/daterangepicker.js"></script>
                <script src="vendor/jquery/jquery.min.js"></script>
                <script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script>

                <!-- Plugin JavaScript -->
                <script src="vendor/jquery-easing/jquery.easing.min.js"></script>


                <script src="js/new-age.min.js"></script>

                <!-- Main JS-->
                <script src="js/global.js"></script>
                <footer>
                    <div class="container">
                        <p>&copy; 好先生 家政服务. 版权所有.</p>
                        <ul class="list-inline">
                            <li class="list-inline-item">
                                <a href="#">隐私</a>
                            </li>
                            <li class="list-inline-item">
                                <a href="#">条款</a>
                            </li>
                        </ul>
                    </div>
                </footer>
            </body>
            <!-- end document-->

            </html>
<?php

        }
    }
}
?>